UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dJOLtlc/0iI4AhurDoL5Dt28VUE13nykcTuzYc9Q67w='
WHERE
key_id = 'd8975e09f9f6617a063801580c5623a775a099e685d6eba0795c23b866e4785d'
AND (
token = 'dJOLtlc/0iI4AhurDoL5Dt28VUE13nykcTuzYc9Q67w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)