UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNs8HC3IzO9tPlVaSWvhE1A9pbYqnaYuN9NsrvkuGKM='
WHERE
key_id = 'd7482c673c89df735db34845d940d4807412d41a13d3bd7f081d45f6354fd82c'
AND (
token = 'pNs8HC3IzO9tPlVaSWvhE1A9pbYqnaYuN9NsrvkuGKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)