UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sK0DMDDtMYbcblNjQCHYkEyG8nAqfs7jvJiyD/0quso='
WHERE
key_id = 'd49ed1fbfe4d085d245de30b51853c62de81383f71634d977d4fce94c803821d'
AND (
token = 'sK0DMDDtMYbcblNjQCHYkEyG8nAqfs7jvJiyD/0quso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)