UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xCOOpm1ShH7fFIL21ilO+w0cnA62oTra0wEakZcNBg4='
WHERE
key_id = 'ceaafde1bfcc98c57a7b630102f0dbb0e164ba90a90ddecc7869573b3a8e798d'
AND (
token = 'xCOOpm1ShH7fFIL21ilO+w0cnA62oTra0wEakZcNBg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)