UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KksJDUQPO72tod9L/lEZ8OuNCaIwOly9t71VC1Yl6Lw='
WHERE
key_id = '3425fe7d391413cb0f959b17a59a0e8628456d50ac2173b9221af1de03d9605a'
AND (
token = 'KksJDUQPO72tod9L/lEZ8OuNCaIwOly9t71VC1Yl6Lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)