UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K9vNFU8493PuE28n1lRsChlGLUyZIZGRTUAyTL1lfGs='
WHERE
key_id = '2d1f955bfa0b8c5fe3e681b2218e9944e99bf7ed0b819619a59c86407d155f3a'
AND (
token = 'K9vNFU8493PuE28n1lRsChlGLUyZIZGRTUAyTL1lfGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)