UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4J5mIOtiq4ro+w6uUlwyvpwB8mHMRuQxPr4mkc2yyWA='
WHERE
key_id = 'c58014e418afbea3a8effc119598b6eb95b85a0fa730c6a0e14d03024f036d85'
AND (
token = '4J5mIOtiq4ro+w6uUlwyvpwB8mHMRuQxPr4mkc2yyWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)