UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XeeS/ttMaX00d/aIAIn0K7JNX0ZBfYfcjkzKfvNyvGg='
WHERE
key_id = '96d95882331802e52ee15002201e8a70bf84ad46581fa7c0f93bae821ee8537f'
AND (
token = 'XeeS/ttMaX00d/aIAIn0K7JNX0ZBfYfcjkzKfvNyvGg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)