UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YHo5xv8K4JmMmsXdTxuT3Z0SdC4TAe83vb2H1af+GUE='
WHERE
key_id = '76366c9ced8670baae51dbcc587e45db84254e557217fd25849e10caef8c12e6'
AND (
token = 'YHo5xv8K4JmMmsXdTxuT3Z0SdC4TAe83vb2H1af+GUE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)