UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EfbrhbfJyKlOytMT60BqYMFKMTLJVRESXbfmADHiJqE='
WHERE
key_id = '0c60a5bbd267b7076ee96e39df7b238ab7809f8501ee5da17cc8528c1e17288d'
AND (
token = 'EfbrhbfJyKlOytMT60BqYMFKMTLJVRESXbfmADHiJqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)