UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O7tRKXEpP+HiTfo+QCYa4X+ftS2KHK6Cx0J5uHaU1k4='
WHERE
key_id = '683368a012f104e6fbb5cd52e7bc64310db6c3ef1bffea1c232a1f750767fe0c'
AND (
token = 'O7tRKXEpP+HiTfo+QCYa4X+ftS2KHK6Cx0J5uHaU1k4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)