UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u78cAaW08L4rmwdUKXYGzWB7oqICv1dyLTb67YJLHCg='
WHERE
key_id = '763b6aeb3dbca2f42ca5a6ec26afa23617393cb6e74f02ade79968e7f749b6e5'
AND (
token = 'u78cAaW08L4rmwdUKXYGzWB7oqICv1dyLTb67YJLHCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)