UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QSnyKa9ZXwbG0DiqUs8P7kmrtu362/wxsh5V1/frNQg='
WHERE
key_id = 'e041398848c15f1158b7376e91d70775fc2522e35497376b338ffe6a39ff3003'
AND (
token = 'QSnyKa9ZXwbG0DiqUs8P7kmrtu362/wxsh5V1/frNQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)