UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYaGE61eygsnnAkOnlJQ0iSKa7NThVNDJLdebn03grs='
WHERE
key_id = '84652ec246f579114b91b55d00088af453aadf849f70a285c3844d15bc5885bf'
AND (
token = 'pYaGE61eygsnnAkOnlJQ0iSKa7NThVNDJLdebn03grs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)