UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1y6vI5+4DZ6c+9IG4NgOmqu86RPHKwGxQLWMXISVuPo='
WHERE
key_id = 'c1383745890b8976befdd0e977c745fcdbf4f9fc13f48a4af4a870a5a5477aca'
AND (
token = '1y6vI5+4DZ6c+9IG4NgOmqu86RPHKwGxQLWMXISVuPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)