UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uiNMbwVQ9l9YCfHRmRg4gHu/99+qLZcaxak4K5M86/Q='
WHERE
key_id = 'f7670cf06651100d8d88538e4107dab51a6f5e6901bfca4b6e52baa023fe2bd0'
AND (
token = 'uiNMbwVQ9l9YCfHRmRg4gHu/99+qLZcaxak4K5M86/Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)