UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y9kzH4WwTGdCCc6Wk14r+QDU8lhHpkbyDrC5vktK1Nc='
WHERE
key_id = '47bbd55bc2dce203e4af13e1307d43190c5e0eec049f84b2ffec13e525177bdc'
AND (
token = 'Y9kzH4WwTGdCCc6Wk14r+QDU8lhHpkbyDrC5vktK1Nc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)