UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/9Hov7IaTsOznlHo1M6gxlWAQCncaY3Y926zJvztGnM='
WHERE
key_id = 'd607ae91d64f85770d2453692fd2f06b0d7ec24df96056af877ae6847f916a09'
AND (
token = '/9Hov7IaTsOznlHo1M6gxlWAQCncaY3Y926zJvztGnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)