UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnZ/ZHvIrMHuYi2ojazpZ9l1SbEjfD7Aof/iMczLltg='
WHERE
key_id = '501f56afef047324e8767d3600b1fcf7dc4899580ba975d1fa0511377d227ab2'
AND (
token = 'vnZ/ZHvIrMHuYi2ojazpZ9l1SbEjfD7Aof/iMczLltg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)