UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nPLNzVwiTkMade14hw4dvJaX0BJRIzwOWk+C9aTmd5g='
WHERE
key_id = '8e4b8c52587d0db1e553d0fe69da690e6c30308d53a4e4040463a10d6b9fe3df'
AND (
token = 'nPLNzVwiTkMade14hw4dvJaX0BJRIzwOWk+C9aTmd5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)