UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CGTj5oLMG0KJKFYxg7P8Tm28dCyOO4LUKaGZ+/G5EBw='
WHERE
key_id = '45c9803117287c525523ffcb79841ce5d9b9bdf96a14717f06fa7942cef0e5fd'
AND (
token = 'CGTj5oLMG0KJKFYxg7P8Tm28dCyOO4LUKaGZ+/G5EBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)