UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mOZfygZqYCPrKse7WhmGpDxWeMjEIafbbd3om/XaGaU='
WHERE
key_id = '938111d4495c9b74103df4d446bd429d292bf9f119820fdd724ebebb2dbcf97a'
AND (
token = 'mOZfygZqYCPrKse7WhmGpDxWeMjEIafbbd3om/XaGaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)