UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qxn/hD7Jk6F0uOkCsg7JNPinUSHNJAFpyeKVMiJVMIE='
WHERE
key_id = '8a842545ba0de341184499ea78a4270b3548a862eb0fe47daafab81fea2e4f3a'
AND (
token = 'qxn/hD7Jk6F0uOkCsg7JNPinUSHNJAFpyeKVMiJVMIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)