UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jn7W5cvw2a+YldzHjABMHodUIp+m1bYiZcfVo+OzOXE='
WHERE
key_id = '9fbf6cc02bce86959034075034b717c67b05ec5bb382eea01d33dd49c7d5650c'
AND (
token = 'Jn7W5cvw2a+YldzHjABMHodUIp+m1bYiZcfVo+OzOXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)