UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9Srs/UK97aewPTUmwarFL+XBBvpa679SaYuIKebzdo='
WHERE
key_id = '712c92997f91d7a27a94e9e3c2890c0f8f0a01b465b60d8ef155eff3fec93054'
AND (
token = 'r9Srs/UK97aewPTUmwarFL+XBBvpa679SaYuIKebzdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)