UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jN9SHPbSa3mRXne+meMuBRewkm9FDBNWjq3h7CaTqpg='
WHERE
key_id = '8d99ac0f65c69b26606754bab60df78e619e8ca052e1ac497c56f2ee61f4b2b1'
AND (
token = 'jN9SHPbSa3mRXne+meMuBRewkm9FDBNWjq3h7CaTqpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)