UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9MzCLyKlclmf9O9487JWEX+e5fcoULUqPKoRzcU4erg='
WHERE
key_id = '8968477699495b0d220a13f29f79e0a4d795b4232d97660c23e6b8147d13a1fc'
AND (
token = '9MzCLyKlclmf9O9487JWEX+e5fcoULUqPKoRzcU4erg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)