UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l4yFVp7gJPPxLY/4IGYxxwz8b/o9bNBzCvQAOfMQL8g='
WHERE
key_id = '9f47e7515f4db2e1f7ae92bcdea7082fc6e076a09cf5c048d5815ab8884e4c0f'
AND (
token = 'l4yFVp7gJPPxLY/4IGYxxwz8b/o9bNBzCvQAOfMQL8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)