UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S6GKY3lBvD0rhjQ+CT6zkY/PdlKIryEpGtGPng8ZD08='
WHERE
key_id = '74c00c36f3c94523781e42481be804b4a501975e738e917cdb0ece9df36674d1'
AND (
token = 'S6GKY3lBvD0rhjQ+CT6zkY/PdlKIryEpGtGPng8ZD08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)