UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8TK9nqvhuCTTuEqUOY9eNeFPcWuBlWJIHRVgdJHjXo='
WHERE
key_id = '78c166e7afb4d57094ea80b6ea6a87601a45d26a5a4d38969d027132eb7fad2a'
AND (
token = '/8TK9nqvhuCTTuEqUOY9eNeFPcWuBlWJIHRVgdJHjXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)