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